Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	17107
Missing cells	22043
Missing cells (%)	5.9%
Duplicate rows	220
Duplicate rows (%)	1.3%
Total size in memory	2.9 MiB
Average record size in memory	177.0 B

Variable types

Numeric	15
Categorical	4
DateTime	2
Boolean	1

Alerts

Dataset has 220 (1.3%) duplicate rows	Duplicates
`post_text` has a high cardinality: 13838 distinct values	High cardinality
`post_id` is highly correlated with `reaction_count`	High correlation
`likes` is highly correlated with `comments` and 6 other fields	High correlation
`comments` is highly correlated with `likes` and 1 other fields	High correlation
`shares` is highly correlated with `likes` and 1 other fields	High correlation
`reaction_count` is highly correlated with `post_id` and 7 other fields	High correlation
`Like` is highly correlated with `reaction_count` and 5 other fields	High correlation
`Love` is highly correlated with `reaction_count` and 5 other fields	High correlation
`Wow` is highly correlated with `likes` and 6 other fields	High correlation
`Sad` is highly correlated with `likes` and 6 other fields	High correlation
`Angry` is highly correlated with `likes` and 6 other fields	High correlation
`Care` is highly correlated with `likes` and 6 other fields	High correlation
`likes` is highly correlated with `reaction_count` and 4 other fields	High correlation
`reaction_count` is highly correlated with `likes` and 4 other fields	High correlation
`Like` is highly correlated with `likes` and 4 other fields	High correlation
`Love` is highly correlated with `likes` and 4 other fields	High correlation
`Wow` is highly correlated with `likes` and 3 other fields	High correlation
`Sad` is highly correlated with `Angry`	High correlation
`Angry` is highly correlated with `Sad`	High correlation
`Care` is highly correlated with `likes` and 3 other fields	High correlation
`likes` is highly correlated with `comments` and 1 other fields	High correlation
`comments` is highly correlated with `likes`	High correlation
`reaction_count` is highly correlated with `likes` and 6 other fields	High correlation
`Like` is highly correlated with `reaction_count` and 5 other fields	High correlation
`Love` is highly correlated with `reaction_count` and 5 other fields	High correlation
`Wow` is highly correlated with `reaction_count` and 5 other fields	High correlation
`Sad` is highly correlated with `reaction_count` and 5 other fields	High correlation
`Angry` is highly correlated with `reaction_count` and 5 other fields	High correlation
`Care` is highly correlated with `reaction_count` and 5 other fields	High correlation
`post_id` is highly correlated with `username`	High correlation
`likes` is highly correlated with `reaction_count` and 4 other fields	High correlation
`comments` is highly correlated with `reaction_count` and 5 other fields	High correlation
`shares` is highly correlated with `Like` and 2 other fields	High correlation
`username` is highly correlated with `post_id` and 2 other fields	High correlation
`reaction_count` is highly correlated with `likes` and 6 other fields	High correlation
`Like` is highly correlated with `likes` and 7 other fields	High correlation
`Love` is highly correlated with `likes` and 6 other fields	High correlation
`Wow` is highly correlated with `likes` and 8 other fields	High correlation
`Sad` is highly correlated with `comments` and 6 other fields	High correlation
`Angry` is highly correlated with `likes` and 2 other fields	High correlation
`Care` is highly correlated with `comments` and 6 other fields	High correlation
`Weekday` is highly correlated with `Day`	High correlation
`Day` is highly correlated with `username` and 1 other fields	High correlation
`Hour` is highly correlated with `username`	High correlation
`timestamp` has 9467 (55.3%) missing values	Missing
`likes` has 2333 (13.6%) missing values	Missing
`reaction_count` has 10243 (59.9%) missing values	Missing
`likes` is highly skewed (γ1 = 37.44574063)	Skewed
`comments` is highly skewed (γ1 = 71.48847167)	Skewed
`shares` is highly skewed (γ1 = 48.03356063)	Skewed
`Love` is highly skewed (γ1 = 25.25020846)	Skewed
`Angry` is highly skewed (γ1 = 20.46354447)	Skewed
`Care` is highly skewed (γ1 = 25.43157297)	Skewed
`comments` has 1797 (10.5%) zeros	Zeros
`shares` has 2508 (14.7%) zeros	Zeros
`Like` has 10243 (59.9%) zeros	Zeros
`Love` has 10979 (64.2%) zeros	Zeros
`Wow` has 12182 (71.2%) zeros	Zeros
`Sad` has 12328 (72.1%) zeros	Zeros
`Angry` has 12232 (71.5%) zeros	Zeros
`Care` has 12435 (72.7%) zeros	Zeros
`Minute` has 875 (5.1%) zeros	Zeros
`Hour` has 181 (1.1%) zeros	Zeros

Reproduction

Analysis started	2021-12-10 21:32:36.728097
Analysis finished	2021-12-10 21:33:26.318077
Duration	49.59 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

post_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	15722
Distinct (%)	91.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.834233898 × 10¹⁵

Minimum	1.056919014 × 10¹⁴
Maximum	1.016044166 × 10¹⁶
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	1.056919014 × 10¹⁴
5-th percentile	1.985850383 × 10¹⁴
Q1	4.06963561 × 10¹⁴
median	8.636305042 × 10¹⁴
Q3	4.243907789 × 10¹⁵
95-th percentile	1.015933768 × 10¹⁶
Maximum	1.016044166 × 10¹⁶
Range	1.005474976 × 10¹⁶
Interquartile range (IQR)	3.836944228 × 10¹⁵

Descriptive statistics

Standard deviation	3.622284461 × 10¹⁵
Coefficient of variation (CV)	1.278047117
Kurtosis	0.05365032852
Mean	2.834233898 × 10¹⁵
Median Absolute Deviation (MAD)	5.86595757 × 10¹⁴
Skewness	1.304723119
Sum	-6.854992929 × 10¹⁸
Variance	1.312094472 × 10³¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.015921876 × 10¹⁶	5	< 0.1%
1.015921876 × 10¹⁶	5	< 0.1%
1.015922523 × 10¹⁶	4	< 0.1%
1.04504267 × 10¹⁵	3	< 0.1%
5.012509713 × 10¹⁴	3	< 0.1%
2.483759837 × 10¹⁴	3	< 0.1%
1.83446918 × 10¹⁵	3	< 0.1%
5.414053838 × 10¹⁴	3	< 0.1%
8.794811063 × 10¹⁴	3	< 0.1%
9.664029906 × 10¹⁴	3	< 0.1%
Other values (15712)	17072	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.056919014 × 10¹⁴	1	< 0.1%
1.058777581 × 10¹⁴	1	< 0.1%
1.066903514 × 10¹⁴	1	< 0.1%
1.067466514 × 10¹⁴	1	< 0.1%
1.068339479 × 10¹⁴	1	< 0.1%
1.076193145 × 10¹⁴	1	< 0.1%
1.078697413 × 10¹⁴	1	< 0.1%
1.093922079 × 10¹⁴	1	< 0.1%
1.099065109 × 10¹⁴	1	< 0.1%
1.104335342 × 10¹⁴	1	< 0.1%

Value	Count	Frequency (%)
1.016044166 × 10¹⁶	1	< 0.1%
1.016044166 × 10¹⁶	1	< 0.1%
1.016044161 × 10¹⁶	1	< 0.1%
1.016044161 × 10¹⁶	1	< 0.1%
1.01604416 × 10¹⁶	1	< 0.1%
1.016044157 × 10¹⁶	1	< 0.1%
1.016044156 × 10¹⁶	1	< 0.1%
1.016044155 × 10¹⁶	1	< 0.1%
1.016044147 × 10¹⁶	1	< 0.1%
1.016044147 × 10¹⁶	1	< 0.1%

post_text
Categorical

HIGH CARDINALITY

Distinct	13838
Distinct (%)	80.9%
Missing	0
Missing (%)	0.0%
Memory size	267.3 KiB

	351
#Diga_Diga	80
#BusinessNews	54
🔶 آخر الأخبار الرياضية في الكرونوسبور #Chronosport #ShemsFm	37
#DigaDiga	37
Other values (13833)	16548

Length

Max length	1916
Median length	82
Mean length	104.7989127
Min length	0

Characters and Unicode

Total characters	1792795
Distinct characters	827
Distinct categories	21 ?
Distinct scripts	4 ?
Distinct blocks	16 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12163 ?
Unique (%)	71.1%

Sample

1st row	⚽️ 🎁 1200 دينار كاش للربح مع Tunisiabet.net بعد ايقاف مقابلة #ليون و #مارسيليا ، التفاصيل في الفيديو 👇👇 Tunisiabet.net #Stade_Med by #Radio_Med #tunisiaBet
2nd row	اخماد حريق بنزل بالحمامات الشمالية
3rd row	يتجدد موعدكم مع #مروى_المعموري من الاثنين للجمعة في #Be_Cool من ال-19 🕖 حتى ال-21🕘 👈 تبعونا تلقاو كل ما يهمكم مع برشا موجات ايجابية على #راديو_ماد ----------------- Suivez-nous 🎙 \| Live : https://radiomedtunisie.com/LIVE 📸 \| Instagram : https://www.instagram.com/radiomedtn/ 📱 \| Facebook : https://www.facebook.com/RadioMedTunisie
4th row	تونس تستضيف فعالية “صنع في ليبيا” لدعم شراكة البلدين
5th row	#L'affiche : نقترحو عليكم سلسلة تاريخية من أنجح الأعمال الكورية الجنوبية (المملكة)

Common Values

Value	Count	Frequency (%)
	351	2.1%
#Diga_Diga	80	0.5%
#BusinessNews	54	0.3%
🔶 آخر الأخبار الرياضية في الكرونوسبور #Chronosport #ShemsFm	37	0.2%
#DigaDiga	37	0.2%
أخبار السابعة صباحاً مع بسمة سعايدية Nouvelles de sept heures du matin avec Basma Saidia	29	0.2%
أخبار منتصف النهار مع بسمة سعايدية Nouvelles de mi-journée avec Basma Saidia	25	0.1%
معرض الصحافة مع منال جاء بالله	21	0.1%
برنامج Perla Kids مباشرة من فضاء هدهود	20	0.1%
اشري تربح مع خالد وفرج وصابر	20	0.1%
Other values (13828)	16433	96.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	9494	3.3%
في	7632	2.7%
و	5751	2.0%
من	4282	1.5%
مع	4207	1.5%
على	3443	1.2%
تونس	1445	0.5%
؟	1109	0.4%
اليوم	1052	0.4%
عن	1010	0.4%
Other values (41871)	246784	86.2%

Most occurring characters

Value	Count	Frequency (%)
	245618	13.7%
ا	169165	9.4%
ل	122681	6.8%
ي	96359	5.4%
م	68994	3.8%
و	61830	3.4%
ر	57006	3.2%
ن	55141	3.1%
ت	46151	2.6%
ب	45390	2.5%
Other values (817)	824460	46.0%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	1107226	61.8%
Space Separator	245618	13.7%
Lowercase Letter	233015	13.0%
Other Punctuation	53153	3.0%
Uppercase Letter	42823	2.4%
Other Symbol	28513	1.6%
Control	27510	1.5%
Dash Punctuation	20015	1.1%
Decimal Number	16637	0.9%
Connector Punctuation	8954	0.5%
Other values (11)	9331	0.5%

Most frequent character per category

Other Symbol

Value	Count	Frequency (%)
🇹	3496	12.3%
🇳	3490	12.2%
🔴	3148	11.0%
🎙	1379	4.8%
🔶	987	3.5%
👈	984	3.5%
⚽	955	3.3%
🌐	945	3.3%
✅	616	2.2%
🟠	513	1.8%
Other values (566)	12000	42.1%

Other Letter

Value	Count	Frequency (%)
ا	169165	15.3%
ل	122681	11.1%
ي	96359	8.7%
م	68994	6.2%
و	61830	5.6%
ر	57006	5.1%
ن	55141	5.0%
ت	46151	4.2%
ب	45390	4.1%
ة	43609	3.9%
Other values (71)	340900	30.8%

Lowercase Letter

Value	Count	Frequency (%)
e	29135	12.5%
a	21318	9.1%
s	20006	8.6%
o	17378	7.5%
i	16292	7.0%
t	14712	6.3%
n	12579	5.4%
r	11391	4.9%
m	10832	4.6%
u	10535	4.5%
Other values (31)	68837	29.5%

Uppercase Letter

Value	Count	Frequency (%)
S	5109	11.9%
M	4997	11.7%
L	2801	6.5%
N	2701	6.3%
I	2522	5.9%
T	2495	5.8%
A	2426	5.7%
E	2355	5.5%
R	2151	5.0%
F	2142	5.0%
Other values (21)	13124	30.6%

Other Punctuation

Value	Count	Frequency (%)
#	15876	29.9%
.	10757	20.2%
:	9708	18.3%
/	6690	12.6%
'	2276	4.3%
؟	2118	4.0%
"	2021	3.8%
!	1241	2.3%
،	885	1.7%
*	409	0.8%
Other values (16)	1172	2.2%

Nonspacing Mark

Value	Count	Frequency (%)
ّ	2158	42.1%
️	1472	28.7%
ٔ	306	6.0%
ً	293	5.7%
́	266	5.2%
ُ	243	4.7%
َ	139	2.7%
ِ	72	1.4%
ْ	67	1.3%
ٕ	27	0.5%
Other values (7)	85	1.7%

Format

Value	Count	Frequency (%)
‏	399	34.7%
‎	168	14.6%
󠁧	162	14.1%
‍	87	7.6%
󠁿	82	7.1%
󠁢	82	7.1%
󠁥	80	7.0%
󠁮	80	7.0%
⁦	3	0.3%
󠁴	2	0.2%
Other values (4)	6	0.5%

Decimal Number

Value	Count	Frequency (%)
0	3631	21.8%
1	2979	17.9%
2	2798	16.8%
3	1697	10.2%
9	1062	6.4%
5	1015	6.1%
8	914	5.5%
6	878	5.3%
7	844	5.1%
4	817	4.9%

Math Symbol

Value	Count	Frequency (%)
\|	991	62.5%
>	273	17.2%
◾	208	13.1%
+	56	3.5%
=	32	2.0%
◼	22	1.4%
<	3	0.2%
~	1	0.1%

Final Punctuation

Value	Count	Frequency (%)
’	230	73.5%
”	69	22.0%
»	14	4.5%

Initial Punctuation

Value	Count	Frequency (%)
“	45	61.6%
«	17	23.3%
‘	11	15.1%

Modifier Symbol

Value	Count	Frequency (%)
🏻	7	58.3%
🏼	3	25.0%
`	2	16.7%

Dash Punctuation

Value	Count	Frequency (%)
-	20006	> 99.9%
–	9	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	387	99.7%
》	1	0.3%

Open Punctuation

Value	Count	Frequency (%)
(	376	99.7%
《	1	0.3%

Currency Symbol

Value	Count	Frequency (%)
€	2	66.7%
$	1	33.3%

Space Separator

Value	Count	Frequency (%)
	245618	100.0%

Control

Value	Count	Frequency (%)
	27510	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	8954	100.0%

Modifier Letter

Value	Count	Frequency (%)
ـ	275	100.0%

Enclosing Mark

Value	Count	Frequency (%)
⃣	25	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Arabic	1107235	61.8%
Common	404482	22.6%
Latin	275838	15.4%
Inherited	5240	0.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
	245618	60.7%
	27510	6.8%
-	20006	4.9%
#	15876	3.9%
.	10757	2.7%
:	9708	2.4%
_	8954	2.2%
/	6690	1.7%
0	3631	0.9%
🇹	3496	0.9%
Other values (641)	52236	12.9%

Arabic

Value	Count	Frequency (%)
ا	169165	15.3%
ل	122681	11.1%
ي	96359	8.7%
م	68994	6.2%
و	61830	5.6%
ر	57006	5.1%
ن	55141	5.0%
ت	46151	4.2%
ب	45390	4.1%
ة	43609	3.9%
Other values (75)	340909	30.8%

Latin

Value	Count	Frequency (%)
e	29135	10.6%
a	21318	7.7%
s	20006	7.3%
o	17378	6.3%
i	16292	5.9%
t	14712	5.3%
n	12579	4.6%
r	11391	4.1%
m	10832	3.9%
u	10535	3.8%
Other values (62)	111660	40.5%

Inherited

Value	Count	Frequency (%)
ّ	2158	41.2%
️	1472	28.1%
ٔ	306	5.8%
ً	293	5.6%
́	266	5.1%
ُ	243	4.6%
َ	139	2.7%
‍	87	1.7%
ِ	72	1.4%
ْ	67	1.3%
Other values (9)	137	2.6%

Most occurring blocks

Value	Count	Frequency (%)
Arabic	1113826	62.1%
ASCII	642390	35.8%
None	19980	1.1%
Enclosed Alphanum Sup	7835	0.4%
Punctuation	1518	0.1%
Dingbats	1508	0.1%
VS	1478	0.1%
Misc Symbols	1443	0.1%
Geometric Shapes Ext	920	0.1%
Emoticons	532	< 0.1%
Other values (6)	1365	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	245618	38.2%
e	29135	4.5%
	27510	4.3%
a	21318	3.3%
s	20006	3.1%
-	20006	3.1%
o	17378	2.7%
i	16292	2.5%
#	15876	2.5%
t	14712	2.3%
Other values (80)	214539	33.4%

Arabic

Value	Count	Frequency (%)
ا	169165	15.2%
ل	122681	11.0%
ي	96359	8.7%
م	68994	6.2%
و	61830	5.6%
ر	57006	5.1%
ن	55141	5.0%
ت	46151	4.1%
ب	45390	4.1%
ة	43609	3.9%
Other values (52)	347500	31.2%

Enclosed Alphanum Sup

Value	Count	Frequency (%)
🇹	3496	44.6%
🇳	3490	44.5%
🇪	214	2.7%
🇩	93	1.2%
🇮	80	1.0%
🇷	79	1.0%
🇫	75	1.0%
🇸	70	0.9%
🇧	68	0.9%
🇱	65	0.8%
Other values (19)	105	1.3%

None

Value	Count	Frequency (%)
🔴	3148	15.8%
é	1889	9.5%
🎙	1379	6.9%
ï	1319	6.6%
🔶	987	4.9%
👈	984	4.9%
🌐	945	4.7%
🔸	512	2.6%
🌤	470	2.4%
🔵	437	2.2%
Other values (494)	7910	39.6%

VS

Value	Count	Frequency (%)
️	1472	99.6%
︎	6	0.4%

Misc Symbols

Value	Count	Frequency (%)
⚽	955	66.2%
☎	132	9.1%
☑	40	2.8%
☄	28	1.9%
⛔	25	1.7%
⛈	22	1.5%
☕	20	1.4%
☔	20	1.4%
⚠	18	1.2%
♂	17	1.2%
Other values (30)	166	11.5%

Dingbats

Value	Count	Frequency (%)
✅	616	40.8%
➕	281	18.6%
➡	176	11.7%
✨	146	9.7%
❤	91	6.0%
❓	58	3.8%
✍	36	2.4%
✌	21	1.4%
❌	17	1.1%
✈	16	1.1%
Other values (9)	50	3.3%

Geometric Shapes Ext

Value	Count	Frequency (%)
🟠	513	55.8%
🟡	257	27.9%
🟢	57	6.2%
🟥	39	4.2%
🟣	39	4.2%
🟤	7	0.8%
🟨	4	0.4%
🟩	4	0.4%

Punctuation

Value	Count	Frequency (%)
‏	399	26.3%
’	230	15.2%
′	214	14.1%
‎	168	11.1%
…	151	9.9%
‍	87	5.7%
”	69	4.5%
‼	63	4.2%
•	59	3.9%
“	45	3.0%
Other values (6)	33	2.2%

Geometric Shapes

Value	Count	Frequency (%)
▪	285	55.0%
◾	208	40.2%
◼	22	4.2%
■	3	0.6%

Diacriticals

Value	Count	Frequency (%)
́	266	89.9%
̈	21	7.1%
̀	6	2.0%
̂	3	1.0%

Emoticons

Value	Count	Frequency (%)
😍	144	27.1%
😂	71	13.3%
😋	42	7.9%
😷	31	5.8%
😲	30	5.6%
🙄	26	4.9%
😮	25	4.7%
😘	19	3.6%
😳	16	3.0%
😱	14	2.6%
Other values (24)	114	21.4%

Misc Technical

Value	Count	Frequency (%)
⏱	28	53.8%
⏰	11	21.2%
⌚	9	17.3%
⏬	3	5.8%
⏳	1	1.9%

Specials

Value	Count	Frequency (%)
�	5	100.0%

Currency Symbols

Value	Count	Frequency (%)
€	2	100.0%

time
Date

Distinct	15722
Distinct (%)	91.9%
Missing	0
Missing (%)	0.0%
Memory size	267.3 KiB

Minimum	2019-09-25 12:41:12
Maximum	2021-11-27 09:06:11

Histogram

Histogram with fixed size bins (bins=50)

timestamp
Date

MISSING

Distinct	7122
Distinct (%)	93.2%
Missing	9467
Missing (%)	55.3%
Memory size	267.3 KiB

Minimum	2019-09-25 11:41:12
Maximum	2021-11-22 19:16:40

Histogram

Histogram with fixed size bins (bins=50)

likes
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED

Distinct	1464
Distinct (%)	9.9%
Missing	2333
Missing (%)	13.6%
Infinite	0
Infinite (%)	0.0%
Mean	1433.692365

Minimum	0
Maximum	577803
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	10
Q1	31
median	81
Q3	297
95-th percentile	5649
Maximum	577803
Range	577803
Interquartile range (IQR)	266

Descriptive statistics

Standard deviation	9433.885096
Coefficient of variation (CV)	6.580132061
Kurtosis	2036.616141
Mean	1433.692365
Median Absolute Deviation (MAD)	64
Skewness	37.44574063
Sum	21181371
Variance	88998188.01
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	185	1.1%
11	174	1.0%
17	174	1.0%
21	163	1.0%
9	161	0.9%
13	158	0.9%
18	157	0.9%
10	147	0.9%
8	146	0.9%
12	145	0.8%
Other values (1454)	13164	77.0%
(Missing)	2333	13.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	7	< 0.1%
2	22	0.1%
3	52	0.3%
4	42	0.2%
5	85	0.5%
6	78	0.5%
7	113	0.7%
8	146	0.9%
9	161	0.9%

Value	Count	Frequency (%)
577803	1	< 0.1%
574390	1	< 0.1%
338402	1	< 0.1%
233416	1	< 0.1%
228796	1	< 0.1%
155710	1	< 0.1%
150962	1	< 0.1%
140940	1	< 0.1%
76980	1	< 0.1%
76000	1	< 0.1%

comments
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	769
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	170.2038931

Minimum	0
Maximum	182227
Zeros	1797
Zeros (%)	10.5%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	8
Q3	33
95-th percentile	368.7
Maximum	182227
Range	182227
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	2153.172056
Coefficient of variation (CV)	12.65054528
Kurtosis	5980.791421
Mean	170.2038931
Median Absolute Deviation (MAD)	7
Skewness	71.48847167
Sum	2911678
Variance	4636149.904
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1797	10.5%
1	1608	9.4%
2	1200	7.0%
3	1062	6.2%
4	780	4.6%
5	642	3.8%
6	611	3.6%
7	451	2.6%
8	432	2.5%
9	382	2.2%
Other values (759)	8142	47.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1797	10.5%
1	1608	9.4%
2	1200	7.0%
3	1062	6.2%
4	780	4.6%
5	642	3.8%
6	611	3.6%
7	451	2.6%
8	432	2.5%
9	382	2.2%

Value	Count	Frequency (%)
182227	1	< 0.1%
182226	1	< 0.1%
32319	1	< 0.1%
14715	3	< 0.1%
14282	1	< 0.1%
14280	1	< 0.1%
14279	1	< 0.1%
14278	1	< 0.1%
14276	1	< 0.1%
14272	1	< 0.1%

shares
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	670
Distinct (%)	3.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	495.522067

Minimum	0
Maximum	549145
Zeros	2508
Zeros (%)	14.7%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	4
Q3	17
95-th percentile	321.4
Maximum	549145
Range	549145
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	6283.69629
Coefficient of variation (CV)	12.68096157
Kurtosis	3615.181094
Mean	495.522067
Median Absolute Deviation (MAD)	4
Skewness	48.03356063
Sum	8476896
Variance	39484839.07
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2508	14.7%
1	2491	14.6%
2	1659	9.7%
3	1218	7.1%
4	951	5.6%
5	699	4.1%
6	532	3.1%
7	489	2.9%
8	408	2.4%
9	340	2.0%
Other values (660)	5812	34.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2508	14.7%
1	2491	14.6%
2	1659	9.7%
3	1218	7.1%
4	951	5.6%
5	699	4.1%
6	532	3.1%
7	489	2.9%
8	408	2.4%
9	340	2.0%

Value	Count	Frequency (%)
549145	1	< 0.1%
181805	1	< 0.1%
181802	4	< 0.1%
82091	1	< 0.1%
64916	3	< 0.1%
60276	3	< 0.1%
60275	2	< 0.1%
60274	11	0.1%
59774	1	< 0.1%
49020	5	< 0.1%

username
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	267.3 KiB

Mosaïque FM	4461
Jawhara FM	4401
Radio Med Tunisie	3393
Nessma	3045
Shems FM (page officielle)	1807

Length

Max length	26
Median length	11
Mean length	12.62722862
Min length	6

Characters and Unicode

Total characters	216014
Distinct characters	29
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Radio Med Tunisie
2nd row	Radio Med Tunisie
3rd row	Radio Med Tunisie
4th row	Radio Med Tunisie
5th row	Radio Med Tunisie

Common Values

Value	Count	Frequency (%)
Mosaïque FM	4461	26.1%
Jawhara FM	4401	25.7%
Radio Med Tunisie	3393	19.8%
Nessma	3045	17.8%
Shems FM (page officielle)	1807	10.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
fm	10669	27.9%
mosaïque	4461	11.7%
jawhara	4401	11.5%
tunisie	3393	8.9%
med	3393	8.9%
radio	3393	8.9%
nessma	3045	8.0%
officielle	1807	4.7%
page	1807	4.7%
shems	1807	4.7%

Most occurring characters

Value	Count	Frequency (%)
a	25909	12.0%
e	21520	10.0%
	21069	9.8%
M	18523	8.6%
s	15751	7.3%
i	13793	6.4%
F	10669	4.9%
o	9661	4.5%
u	7854	3.6%
d	6786	3.1%
Other values (19)	64479	29.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	146100	67.6%
Uppercase Letter	45231	20.9%
Space Separator	21069	9.8%
Open Punctuation	1807	0.8%
Close Punctuation	1807	0.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	25909	17.7%
e	21520	14.7%
s	15751	10.8%
i	13793	9.4%
o	9661	6.6%
u	7854	5.4%
d	6786	4.6%
h	6208	4.2%
m	4852	3.3%
q	4461	3.1%
Other values (9)	29305	20.1%

Uppercase Letter

Value	Count	Frequency (%)
M	18523	41.0%
F	10669	23.6%
J	4401	9.7%
R	3393	7.5%
T	3393	7.5%
N	3045	6.7%
S	1807	4.0%

Space Separator

Value	Count	Frequency (%)
	21069	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1807	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1807	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	191331	88.6%
Common	24683	11.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	25909	13.5%
e	21520	11.2%
M	18523	9.7%
s	15751	8.2%
i	13793	7.2%
F	10669	5.6%
o	9661	5.0%
u	7854	4.1%
d	6786	3.5%
h	6208	3.2%
Other values (16)	54657	28.6%

Common

Value	Count	Frequency (%)
	21069	85.4%
(	1807	7.3%
)	1807	7.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	211553	97.9%
None	4461	2.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	25909	12.2%
e	21520	10.2%
	21069	10.0%
M	18523	8.8%
s	15751	7.4%
i	13793	6.5%
F	10669	5.0%
o	9661	4.6%
u	7854	3.7%
d	6786	3.2%
Other values (18)	60018	28.4%

None

Value	Count	Frequency (%)
ï	4461	100.0%

is_live
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	150.4 KiB

False	17106
True	1

Common Values
Chart

Value	Count	Frequency (%)
False	17106	> 99.9%
True	1	< 0.1%

reaction_count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	1897
Distinct (%)	27.6%
Missing	10243
Missing (%)	59.9%
Infinite	0
Infinite (%)	0.0%
Mean	37205.272

Minimum	2
Maximum	3962765
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	2
5-th percentile	25
Q1	128.75
median	2527
Q3	30837
95-th percentile	280400.7
Maximum	3962765
Range	3962763
Interquartile range (IQR)	30708.25

Descriptive statistics

Standard deviation	145766.4402
Coefficient of variation (CV)	3.917897447
Kurtosis	251.8596765
Mean	37205.272
Median Absolute Deviation (MAD)	2492
Skewness	13.13364923
Sum	255376987
Variance	2.124785508 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1392	81	0.5%
31246	80	0.5%
31026	79	0.5%
2527	77	0.5%
59434	76	0.4%
5284	56	0.3%
3723	51	0.3%
2526	49	0.3%
4041	48	0.3%
59445	46	0.3%
Other values (1887)	6221	36.4%
(Missing)	10243	59.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	3	< 0.1%
3	8	< 0.1%
4	8	< 0.1%
5	10	0.1%
6	13	0.1%
7	15	0.1%
8	10	0.1%
9	17	0.1%
10	15	0.1%
11	21	0.1%

Value	Count	Frequency (%)
3962765	2	< 0.1%
2613747	1	< 0.1%
2613743	1	< 0.1%
2613742	1	< 0.1%
2613740	1	< 0.1%
2415594	1	< 0.1%
2415593	1	< 0.1%
1723712	1	< 0.1%
1673658	1	< 0.1%
1673632	1	< 0.1%

Like
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1678
Distinct (%)	9.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11129.06933

Minimum	0
Maximum	2949058
Zeros	10243
Zeros (%)	59.9%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	297
95-th percentile	43507
Maximum	2949058
Range	2949058
Interquartile range (IQR)	297

Descriptive statistics

Standard deviation	72451.71584
Coefficient of variation (CV)	6.510132492
Kurtosis	589.2107156
Mean	11129.06933
Median Absolute Deviation (MAD)	0
Skewness	19.68747014
Sum	190384989
Variance	5249251128
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10243	59.9%
2015	85	0.5%
6251	84	0.5%
884	81	0.5%
6327	80	0.5%
1848	77	0.5%
50731	76	0.4%
43507	71	0.4%
12176	61	0.4%
2011	57	0.3%
Other values (1668)	6192	36.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10243	59.9%
1	1	< 0.1%
2	4	< 0.1%
3	11	0.1%
4	10	0.1%
5	15	0.1%
6	20	0.1%
7	8	< 0.1%
8	27	0.2%
9	32	0.2%

Value	Count	Frequency (%)
2949058	2	< 0.1%
2173134	1	< 0.1%
2173130	1	< 0.1%
2173129	2	< 0.1%
1898306	1	< 0.1%
1898305	1	< 0.1%
1326291	1	< 0.1%
1130633	1	< 0.1%
1115043	1	< 0.1%
1115025	1	< 0.1%

Love
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	604
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2148.585024

Minimum	0
Maximum	871171
Zeros	10979
Zeros (%)	64.2%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	10
95-th percentile	8012
Maximum	871171
Range	871171
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	19078.48777
Coefficient of variation (CV)	8.879559131
Kurtosis	805.5897661
Mean	2148.585024
Median Absolute Deviation (MAD)	0
Skewness	25.25020846
Sum	36755844
Variance	363988695.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10979	64.2%
1	585	3.4%
2	385	2.3%
3	249	1.5%
4	179	1.0%
5	135	0.8%
599	126	0.7%
84	111	0.6%
6	110	0.6%
180	108	0.6%
Other values (594)	4140	24.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10979	64.2%
1	585	3.4%
2	385	2.3%
3	249	1.5%
4	179	1.0%
5	135	0.8%
6	110	0.6%
7	60	0.4%
8	73	0.4%
9	55	0.3%

Value	Count	Frequency (%)
871171	2	< 0.1%
516793	1	< 0.1%
516785	2	< 0.1%
496948	1	< 0.1%
395768	2	< 0.1%
374974	7	< 0.1%
374973	3	< 0.1%
374972	6	< 0.1%
352849	3	< 0.1%
352848	1	< 0.1%

Wow
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	290
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53.32898813

Minimum	0
Maximum	14423
Zeros	12182
Zeros (%)	71.2%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	266
Maximum	14423
Range	14423
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	347.9328188
Coefficient of variation (CV)	6.524271901
Kurtosis	570.4387694
Mean	53.32898813
Median Absolute Deviation (MAD)	0
Skewness	19.77182667
Sum	912299
Variance	121057.2464
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12182	71.2%
1	489	2.9%
3	375	2.2%
2	289	1.7%
41	213	1.2%
14	181	1.1%
26	155	0.9%
20	144	0.8%
22	143	0.8%
15	124	0.7%
Other values (280)	2812	16.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12182	71.2%
1	489	2.9%
2	289	1.7%
3	375	2.2%
4	69	0.4%
5	76	0.4%
6	51	0.3%
7	42	0.2%
8	47	0.3%
9	31	0.2%

Value	Count	Frequency (%)
14423	1	< 0.1%
13904	1	< 0.1%
10207	1	< 0.1%
10166	1	< 0.1%
10013	2	< 0.1%
8053	2	< 0.1%
7068	1	< 0.1%
5983	3	< 0.1%
5501	4	< 0.1%
4946	1	< 0.1%

Sad
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	279
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	132.9562752

Minimum	0
Maximum	46907
Zeros	12328
Zeros (%)	72.1%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	104
Maximum	46907
Range	46907
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1922.329296
Coefficient of variation (CV)	14.45835703
Kurtosis	379.7975557
Mean	132.9562752
Median Absolute Deviation (MAD)	0
Skewness	19.1315035
Sum	2274483
Variance	3695349.922
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12328	72.1%
1	643	3.8%
7	262	1.5%
12	254	1.5%
4	235	1.4%
11	219	1.3%
115	203	1.2%
24	196	1.1%
9	194	1.1%
2	155	0.9%
Other values (269)	2418	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12328	72.1%
1	643	3.8%
2	155	0.9%
3	155	0.9%
4	235	1.4%
5	31	0.2%
6	48	0.3%
7	262	1.5%
8	20	0.1%
9	194	1.1%

Value	Count	Frequency (%)
46907	1	< 0.1%
39500	9	0.1%
39499	3	< 0.1%
38448	2	< 0.1%
38446	1	< 0.1%
38443	1	< 0.1%
38435	3	< 0.1%
38433	3	< 0.1%
38421	3	< 0.1%
38411	2	< 0.1%

Angry
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	231
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.57187116

Minimum	0
Maximum	31304
Zeros	12232
Zeros (%)	71.5%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	99
Maximum	31304
Range	31304
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	952.9869043
Coefficient of variation (CV)	13.69787658
Kurtosis	437.9590689
Mean	69.57187116
Median Absolute Deviation (MAD)	0
Skewness	20.46354447
Sum	1190166
Variance	908184.0398
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12232	71.5%
1	613	3.6%
28	378	2.2%
2	360	2.1%
12	347	2.0%
41	229	1.3%
5	212	1.2%
6	207	1.2%
355	184	1.1%
3	153	0.9%
Other values (221)	2192	12.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12232	71.5%
1	613	3.6%
2	360	2.1%
3	153	0.9%
4	103	0.6%
5	212	1.2%
6	207	1.2%
7	27	0.2%
8	25	0.1%
9	112	0.7%

Value	Count	Frequency (%)
31304	1	< 0.1%
20054	8	< 0.1%
20053	4	< 0.1%
19370	2	< 0.1%
19366	1	< 0.1%
19365	1	< 0.1%
19363	2	< 0.1%
19362	4	< 0.1%
19360	3	< 0.1%
19357	2	< 0.1%

Care
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	243
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	235.5775414

Minimum	0
Maximum	90180
Zeros	12435
Zeros (%)	72.7%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	600
Maximum	90180
Range	90180
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	3089.142943
Coefficient of variation (CV)	13.11306216
Kurtosis	686.9447958
Mean	235.5775414
Median Absolute Deviation (MAD)	0
Skewness	25.43157297
Sum	4030025
Variance	9542804.123
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12435	72.7%
1	508	3.0%
12	245	1.4%
2	187	1.1%
32	176	1.0%
543	167	1.0%
77	154	0.9%
93	151	0.9%
150	130	0.8%
28	127	0.7%
Other values (233)	2827	16.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12435	72.7%
1	508	3.0%
2	187	1.1%
3	125	0.7%
4	59	0.3%
5	47	0.3%
6	32	0.2%
7	15	0.1%
8	12	0.1%
9	12	0.1%

Value	Count	Frequency (%)
90180	2	< 0.1%
86716	16	0.1%
54978	3	< 0.1%
54977	1	< 0.1%
43587	1	< 0.1%
40005	3	< 0.1%
26406	2	< 0.1%
20572	1	< 0.1%
16912	1	< 0.1%
15637	3	< 0.1%

Weekday
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	267.3 KiB

Wednesday	3121
Friday	2904
Tuesday	2358
Saturday	2355
Thursday	2303
Other values (2)	4066

Length

Max length	9
Median length	7
Mean length	7.22973052
Min length	6

Characters and Unicode

Total characters	123679
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Monday
2nd row	Monday
3rd row	Monday
4th row	Monday
5th row	Monday

Common Values

Value	Count	Frequency (%)
Wednesday	3121	18.2%
Friday	2904	17.0%
Tuesday	2358	13.8%
Saturday	2355	13.8%
Thursday	2303	13.5%
Monday	2242	13.1%
Sunday	1824	10.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
wednesday	3121	18.2%
friday	2904	17.0%
tuesday	2358	13.8%
saturday	2355	13.8%
thursday	2303	13.5%
monday	2242	13.1%
sunday	1824	10.7%

Most occurring characters

Value	Count	Frequency (%)
d	20228	16.4%
a	19462	15.7%
y	17107	13.8%
u	8840	7.1%
e	8600	7.0%
s	7782	6.3%
r	7562	6.1%
n	7187	5.8%
T	4661	3.8%
S	4179	3.4%
Other values (7)	18071	14.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	106572	86.2%
Uppercase Letter	17107	13.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	20228	19.0%
a	19462	18.3%
y	17107	16.1%
u	8840	8.3%
e	8600	8.1%
s	7782	7.3%
r	7562	7.1%
n	7187	6.7%
i	2904	2.7%
t	2355	2.2%
Other values (2)	4545	4.3%

Uppercase Letter

Value	Count	Frequency (%)
T	4661	27.2%
S	4179	24.4%
W	3121	18.2%
F	2904	17.0%
M	2242	13.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	123679	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	20228	16.4%
a	19462	15.7%
y	17107	13.8%
u	8840	7.1%
e	8600	7.0%
s	7782	6.3%
r	7562	6.1%
n	7187	5.8%
T	4661	3.8%
S	4179	3.4%
Other values (7)	18071	14.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	123679	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
d	20228	16.4%
a	19462	15.7%
y	17107	13.8%
u	8840	7.1%
e	8600	7.0%
s	7782	6.3%
r	7562	6.1%
n	7187	5.8%
T	4661	3.8%
S	4179	3.4%
Other values (7)	18071	14.6%

Day
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	31
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.32121354

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	17
median	21
Q3	25
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.970297165
Coefficient of variation (CV)	0.293796291
Kurtosis	0.3620482385
Mean	20.32121354
Median Absolute Deviation (MAD)	4
Skewness	-0.6908379415
Sum	347635
Variance	35.64444824
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	1591	9.3%
19	1278	7.5%
18	1104	6.5%
23	1097	6.4%
21	1056	6.2%
20	1038	6.1%
27	974	5.7%
26	924	5.4%
22	915	5.3%
17	892	5.2%
Other values (21)	6238	36.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	78	0.5%
2	65	0.4%
3	72	0.4%
4	86	0.5%
5	105	0.6%
6	85	0.5%
7	108	0.6%
8	137	0.8%
9	179	1.0%
10	292	1.7%

Value	Count	Frequency (%)
31	223	1.3%
30	236	1.4%
29	550	3.2%
28	625	3.7%
27	974	5.7%
26	924	5.4%
25	749	4.4%
24	1591	9.3%
23	1097	6.4%
22	915	5.3%

Month
Real number (ℝ_≥0)

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.78236979

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	6
median	9
Q3	11
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.07276388
Coefficient of variation (CV)	0.3498786721
Kurtosis	-0.6896177977
Mean	8.78236979
Median Absolute Deviation (MAD)	2
Skewness	-0.8162594113
Sum	150240
Variance	9.441877863
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
11	5332	31.2%
9	3820	22.3%
12	2825	16.5%
3	2527	14.8%
6	2464	14.4%
10	57	0.3%
1	31	0.2%
8	29	0.2%
5	22	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	31	0.2%
3	2527	14.8%
5	22	0.1%
6	2464	14.4%
8	29	0.2%
9	3820	22.3%
10	57	0.3%
11	5332	31.2%
12	2825	16.5%

Value	Count	Frequency (%)
12	2825	16.5%
11	5332	31.2%
10	57	0.3%
9	3820	22.3%
8	29	0.2%
6	2464	14.4%
5	22	0.1%
3	2527	14.8%
1	31	0.2%

Minute
Real number (ℝ_≥0)

ZEROS

Distinct	60
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.95627521

Minimum	0
Maximum	59
Zeros	875
Zeros (%)	5.1%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	11
median	25
Q3	42
95-th percentile	55
Maximum	59
Range	59
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	17.67783205
Coefficient of variation (CV)	0.6810619749
Kurtosis	-1.223287141
Mean	25.95627521
Median Absolute Deviation (MAD)	15
Skewness	0.1448405279
Sum	444034
Variance	312.5057462
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	875	5.1%
1	701	4.1%
15	438	2.6%
2	422	2.5%
30	403	2.4%
11	386	2.3%
14	365	2.1%
13	364	2.1%
45	349	2.0%
31	328	1.9%
Other values (50)	12476	72.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	875	5.1%
1	701	4.1%
2	422	2.5%
3	321	1.9%
4	305	1.8%
5	295	1.7%
6	237	1.4%
7	220	1.3%
8	225	1.3%
9	268	1.6%

Value	Count	Frequency (%)
59	213	1.2%
58	137	0.8%
57	111	0.6%
56	169	1.0%
55	233	1.4%
54	184	1.1%
53	222	1.3%
52	248	1.4%
51	269	1.6%
50	308	1.8%

Hour
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.19933361

Minimum	0
Maximum	23
Zeros	181
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	267.3 KiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	13
Q3	17
95-th percentile	21
Maximum	23
Range	23
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	5.009498008
Coefficient of variation (CV)	0.379526585
Kurtosis	-0.4741898782
Mean	13.19933361
Median Absolute Deviation (MAD)	4
Skewness	-0.1201498407
Sum	225801
Variance	25.09507029
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
12	1465	8.6%
11	1346	7.9%
10	1153	6.7%
17	1128	6.6%
7	1105	6.5%
8	1078	6.3%
13	1072	6.3%
16	1043	6.1%
18	1040	6.1%
15	944	5.5%
Other values (14)	5733	33.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	181	1.1%
1	127	0.7%
2	139	0.8%
3	74	0.4%
4	56	0.3%
5	116	0.7%
6	412	2.4%
7	1105	6.5%
8	1078	6.3%
9	910	5.3%

Value	Count	Frequency (%)
23	314	1.8%
22	474	2.8%
21	551	3.2%
20	661	3.9%
19	852	5.0%
18	1040	6.1%
17	1128	6.6%
16	1043	6.1%
15	944	5.5%
14	866	5.1%

Year
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	267.3 KiB

2021	10576
2020	5539
2019	992

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	68428
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021
2nd row	2021
3rd row	2021
4th row	2021
5th row	2021

Common Values

Value	Count	Frequency (%)
2021	10576	61.8%
2020	5539	32.4%
2019	992	5.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2021	10576	61.8%
2020	5539	32.4%
2019	992	5.8%

Most occurring characters

Value	Count	Frequency (%)
2	33222	48.6%
0	22646	33.1%
1	11568	16.9%
9	992	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	68428	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	33222	48.6%
0	22646	33.1%
1	11568	16.9%
9	992	1.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	68428	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	33222	48.6%
0	22646	33.1%
1	11568	16.9%
9	992	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	68428	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	33222	48.6%
0	22646	33.1%
1	11568	16.9%
9	992	1.4%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	post_id	post_text	time	timestamp	likes	comments	shares	username	is_live	reaction_count	Weekday	Day	Month	Minute	Hour	Year
0	979693202944224	⚽️ 🎁 1200 دينار كاش للربح مع Tunisiabet.net بعد ايقاف مقابلة #ليون و #مارسيليا ، التفاصيل في الفيديو 👇👇\n\nTunisiabet.net\n#Stade_Med by #Radio_Med\n#tunisiaBet	2021-11-22 14:58:11	2021-11-22 14:08:12	3.0	1	1	Radio Med Tunisie	False	NaN	Monday	22	11	58	14	2021
1	5243859242303198	اخماد حريق بنزل بالحمامات الشمالية	2021-11-22 19:11:20	2021-11-22 18:11:20	12.0	0	0	Radio Med Tunisie	False	NaN	Monday	22	11	11	19	2021
2	5243473002341822	يتجدد موعدكم مع #مروى_المعموري من الاثنين للجمعة في #Be_Cool من ال-19 🕖 حتى ال-21🕘\n👈 تبعونا تلقاو كل ما يهمكم مع برشا موجات ايجابية على #راديو_ماد\n\n-----------------\nSuivez-nous\n🎙 \| Live : https://radiomedtunisie.com/LIVE\n📸 \| Instagram : https://www.instagram.com/radiomedtn/\n📱 \| Facebook : https://www.facebook.com/RadioMedTunisie	2021-11-22 18:55:01	2021-11-22 17:55:01	2.0	0	0	Radio Med Tunisie	False	NaN	Monday	22	11	55	18	2021
3	5243801252308997	تونس تستضيف فعالية “صنع في ليبيا” لدعم شراكة البلدين	2021-11-22 18:46:22	2021-11-22 17:46:22	5.0	0	1	Radio Med Tunisie	False	NaN	Monday	22	11	46	18	2021
4	396392812167201	#L'affiche :\nنقترحو عليكم سلسلة تاريخية من أنجح الأعمال الكورية الجنوبية (المملكة)	2021-11-22 18:23:23	2021-11-22 17:30:16	6.0	0	2	Radio Med Tunisie	False	NaN	Monday	22	11	23	18	2021
5	5243740928981696	الليلة: أمطار متفرقة بأقصى الشمال	2021-11-22 18:21:03	2021-11-22 17:21:03	21.0	0	0	Radio Med Tunisie	False	NaN	Monday	22	11	21	18	2021
6	498523994595303	🔴مشاركة تونسية متميزة في معرض صنع في ليبيا\n📞محمد داود رئيس الغرفة الفتية الاقتصادية التونسية	2021-11-22 18:12:06	2021-11-22 17:14:30	17.0	0	2	Radio Med Tunisie	False	NaN	Monday	22	11	12	18	2021
7	427256082311864	* "ماسنجر" و"انستجرام" قد لا يحصلان على التشفير الافتراضى حتى 2023.\n* تحديث كروم 96 يتسبب في مشاكل مع تويتر وانستجرام.. اعرف التفاصيل .	2021-11-22 17:50:19	2021-11-22 16:51:39	6.0	0	0	Radio Med Tunisie	False	NaN	Monday	22	11	50	17	2021
8	5243665428989246	وزيرة الصناعة تبحث مع نظيرها الليبي سبل تحقيق الشراكة الاقتصادية بين البلدين	2021-11-22 17:51:35	2021-11-22 16:51:35	34.0	0	2	Radio Med Tunisie	False	NaN	Monday	22	11	51	17	2021
9	5243620012327121	عادل الدعداع يقدم استقالته من رئاسة نادي حمام الأنف	2021-11-22 17:35:32	2021-11-22 16:35:32	14.0	2	1	Radio Med Tunisie	False	NaN	Monday	22	11	35	17	2021

Last rows

	post_id	post_text	time	timestamp	likes	comments	shares	username	is_live	reaction_count	Weekday	Day	Month	Minute	Hour	Year
17097	2165089750288283	🔶موضوع علاش و كيفاش: سلوك التونسي أثناء السياقة و مدى احترامو لقواعد الطرقات\n🔸ضيفتنا حنان التميمي عضو المجلس التنفيذي و المكلفة بالشؤون القانونية للجمعية التونسية للوقاية من حوادث الطرقات\n#ShemsFm #AlechOuKifech	2021-11-27 01:14:58	NaT	30.0	8	8	Shems FM (page officielle)	False	NaN	Saturday	27	11	14	1	2021
17098	439125243863227	🔴أبناء شمس أف أم بصوت واحد: لن نركع.. لن نتراجع	2021-11-27 02:15:03	NaT	124.0	29	31	Shems FM (page officielle)	False	NaN	Saturday	27	11	15	2	2021
17099	931728810897199	🔶أخبار الرياضة في الكرونوسبور⚽\n#ShemsFm #ChronoSport	2021-11-27 02:15:09	NaT	20.0	4	1	Shems FM (page officielle)	False	NaN	Saturday	27	11	15	2	2021
17100	1082514098884808	🟠رئيس الحكومة يذكر بالنجاحات الأمنية التي تحققت منذ هجوم باردو\n🔸البنك الدولي يجدّد التزامه بمواصلة دعم تونس ومرافقتها في هذه المرحلة الحسّاسة\n🔸أعوان مجلس النواب ينفّذون وقفة احتجاجية تنديدا ب اعتداءات عبير موسي\n🎙#NewsShemsFm 📻 🇹🇳	2021-11-27 02:15:14	NaT	25.0	9	1	Shems FM (page officielle)	False	NaN	Saturday	27	11	15	2	2021
17101	486210715722958	🟠الأخبار\n🎙#NewsShemsFm 📻 🇹🇳	2021-11-27 03:15:19	NaT	38.0	4	0	Shems FM (page officielle)	False	NaN	Saturday	27	11	15	3	2021
17102	796372897669457	🔶الفوندو مع كريمة الشموسة ورياض الزاوش 🎻🎷 #ShemsFm #ElFoundou	2021-11-27 04:15:23	NaT	24.0	5	3	Shems FM (page officielle)	False	NaN	Saturday	27	11	15	4	2021
17103	898221760971598	🔶آلو مدير : تونس تستعد لإطلاق أول قمر صناعي "تونسي تحدي 1"\n#ShemsFm #LaMatinale	2021-11-27 06:15:27	NaT	124.0	58	69	Shems FM (page officielle)	False	NaN	Saturday	27	11	15	6	2021
17104	1757112811155346	🔶المهمة : وين وصل تحقيق ال48 ساعة الخاص بصب المياه المستعملة من onas في سد سيدي سالم ؟ شنوة صار ؟ و شنوة لقاو ؟ التفاصيل مع أسامة الشوالي\n#ShemsFm #LaMatinale #Almouhema	2021-11-27 06:15:32	NaT	75.0	22	2	Shems FM (page officielle)	False	NaN	Saturday	27	11	15	6	2021
17105	2775076899471023	🔶بوغلاب ما يفلت شي : شيلني وأشيلك\n#ShemsFm #LaMatinale #BoughallebMayfaletChay	2021-11-27 06:15:36	NaT	138.0	66	28	Shems FM (page officielle)	False	NaN	Saturday	27	11	15	6	2021
17106	3717591268355743	🔶Shems Clean\n#ShemsFm #LaMatinale\n\n🔶Shems propre\n#ShemsFm #LaMatinale	2021-11-27 06:15:41	NaT	15.0	3	1	Shems FM (page officielle)	False	NaN	Saturday	27	11	15	6	2021

Most frequently occurring

	post_id	post_text	time	timestamp	likes	comments	shares	username	is_live	reaction_count	Like	Love	Wow	Sad	Angry	Care	Weekday	Day	Month	Minute	Hour	Year	# duplicates
107	10159218760787796	إلغاء بطولة إفريقيا لكرة الطائرة '' سيدات '' في رواندا 🏆💥😮	2021-09-18 17:19:37	2021-09-18 15:19:37	21.0	0	0	Nessma	False	21.0	21.0	0.0	0.0	0.0	0.0	0.0	Saturday	18	9	19	17	2021	5
108	10159218764542796	الرئيس الجزائري يعلن تنكيس العلم إثر وفاة بوتفليقة	2021-09-18 17:20:15	2021-09-18 15:20:15	142.0	12	4	Nessma	False	171.0	142.0	0.0	0.0	26.0	0.0	1.0	Saturday	18	9	20	17	2021	5
116	10159225234982796	رياض الشعيبي: رئيس الجمهورية يحاول التحايل على الدستور بعدم إعلانه صراحة تعليق العمل به	2021-09-21 23:00:06	2021-09-21 21:00:06	64.0	76	3	Nessma	False	103.0	64.0	1.0	1.0	0.0	0.0	0.0	Tuesday	21	9	0	23	2021	4
52	10158556950187796	بيل غايتس : عام 2020 كان مدمرا و الأخبار الجيدة ستأتي مع 2021 !	2020-12-23 23:30:50	2020-12-23 22:30:50	169.0	14	8	Nessma	False	193.0	169.0	16.0	0.0	1.0	0.0	0.0	Wednesday	23	12	30	23	2020	3
159	10159342410272796	عزيزي برج العقرب : يتحدث هذا اليوم عن فرصة للربح أو لإطلاق مشروع كبير تعلق عليه آمالاً كبيرة 😍😘\nأيّا كل واحد يدخل يشوف حظو اليوم شنوة مخبيلو 👈 #نسمة #حظك_اليوم ♈♉♊\nwww.nessma.tv	2021-11-16 09:00:01	2021-11-16 08:00:01	79.0	3	3	Nessma	False	94.0	79.0	14.0	0.0	0.0	0.0	0.0	Tuesday	16	11	0	9	2021	3
166	10159343659557796	الأسد يصدر مرسوما تشريعيا يلغي منصب مفتي الجمهورية	2021-11-16 07:52:02	2021-11-16 06:52:02	117.0	6	2	Nessma	False	122.0	117.0	1.0	0.0	0.0	3.0	0.0	Tuesday	16	11	52	7	2021	3
167	10159343731992796	الدبيبة: لا يمكن أن نتنازل عن الحق الانتخابي أبدا لكنهم خرجوا بقوانين مفصلة على بعض الأشخاص..	2021-11-16 08:50:37	2021-11-16 07:50:37	78.0	2	0	Nessma	False	81.0	78.0	0.0	0.0	0.0	0.0	1.0	Tuesday	16	11	50	8	2021	3
168	10159343756357796		2021-11-16 09:07:22	2021-11-16 08:07:22	50.0	20	2	Nessma	False	53.0	50.0	0.0	0.0	0.0	2.0	0.0	Tuesday	16	11	7	9	2021	3
169	10159343811202796	دفع التعاون الاقتصادي الثنائي محور لقاء سمير ماجول بسفير فرنسا	2021-11-16 09:50:56	2021-11-16 08:50:56	67.0	6	3	Nessma	False	71.0	67.0	0.0	0.0	3.0	0.0	0.0	Tuesday	16	11	50	9	2021	3
170	10159343817957796		2021-11-16 09:56:33	2021-11-16 08:56:33	19.0	1	2	Nessma	False	20.0	19.0	0.0	0.0	0.0	0.0	0.0	Tuesday	16	11	56	9	2021	3

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Symbol

Other Letter

Lowercase Letter

Uppercase Letter

Other Punctuation

Nonspacing Mark

Format

Decimal Number

Math Symbol

Final Punctuation

Initial Punctuation

Modifier Symbol

Dash Punctuation

Close Punctuation

Open Punctuation

Currency Symbol

Space Separator

Control

Connector Punctuation

Modifier Letter

Enclosing Mark

Most occurring scripts

Most frequent character per script

Common

Arabic

Latin

Inherited

Most occurring blocks

Most frequent character per block

ASCII

Arabic

Enclosed Alphanum Sup

None

VS

Misc Symbols

Dingbats

Geometric Shapes Ext

Punctuation

Geometric Shapes

Diacriticals

Tags

Emoticons

Misc Technical

Specials

Currency Symbols

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts